-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2012 年 05 月 14 日 12:37
-- 服务器版本: 5.5.16
-- PHP 版本: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- 数据库: `whutoj`
--

-- --------------------------------------------------------

--
-- 表的结构 `ojanswer`
--

CREATE TABLE IF NOT EXISTS `ojanswer` (
  `ojaId` int(11) NOT NULL AUTO_INCREMENT COMMENT '答案Id',
  `ojlId` int(11) NOT NULL,
  `ojqId` int(11) NOT NULL COMMENT '习题id',
  `ojuId` int(11) NOT NULL COMMENT '用户ID',
  `ojaCode` text NOT NULL COMMENT '答案代码',
  `ojaRunTime` int(11) DEFAULT NULL COMMENT '答案运行时间',
  `ojaRunMemory` int(11) DEFAULT NULL COMMENT '答案运行内存',
  `ojaOutput` text COMMENT '答案运行输出信息',
  `ojaTime` datetime DEFAULT NULL COMMENT '提交时间',
  `ojaMemo` text,
  PRIMARY KEY (`ojaId`),
  KEY `FK_用户提交的答案` (`ojuId`),
  KEY `FK_答案使用的语言` (`ojlId`),
  KEY `FK_问题提交的答案` (`ojqId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='OJ提交的答案' AUTO_INCREMENT=8 ;

--
-- 转存表中的数据 `ojanswer`
--

INSERT INTO `ojanswer` (`ojaId`, `ojlId`, `ojqId`, `ojuId`, `ojaCode`, `ojaRunTime`, `ojaRunMemory`, `ojaOutput`, `ojaTime`, `ojaMemo`) VALUES
(1, 1, 1, 1, '#include <stdio.h>\r\n  \r\n  int main()\r\n{\r\n  int a,b;\r\n  scanf("%d,%d",&a,&b);\r\n  printf("%d",a+b);\r\n  getch();\r\n}\r\n  ', 999, 999, '3', '2012-04-15 14:38:46', '$10000001'),
(2, 2, 2, 1, '#include <iostream>\r\nusing namespace std;\r\n\r\nint main()\r\n{\r\n	int a,b;\r\n	cin>>a;\r\n	cin>>b;\r\n	cout<<a+b<<endl;\r\n	return 0;\r\n}', 999, 999, '3', '2012-04-15 14:44:37', '$1000000A'),
(3, 3, 2, 1, 'import java.io.*;\r\nimport java.util.*;\r\npublic class Main\r\n{\r\n    public static void main(String[] args)\r\n    {\r\n        Scanner cin = new Scanner ( System.in );\r\n        int a,b;\r\n        while(cin.hasNext())\r\n        {\r\n            a=cin.nextInt();\r\n            b=cin.nextInt();\r\n            System.out.println(a+b);\r\n        }\r\n\r\n    }\r\n}', 999, 999, '3', '2012-04-23 14:57:06', '$1000000B'),
(4, 1, 1, 2, '#include <stdio.h>\r\n  \r\nint main()\r\n{\r\n  int a,b;\r\n  scanf("%d,%d",&a,&b);\r\n  printf("%d",a+b);\r\n  getch();\r\n}', 999, 999, '3', '2012-05-14 09:44:32', '$10000001'),
(5, 2, 2, 2, '#include <iostream>\r\nusing namespace std;\r\n\r\nint main()\r\n{\r\n	int a,b;\r\n	cin>>a;\r\n	cin>>b;\r\n	cout<<a+b<<endl;\r\n	return 0;\r\n}', 999, 999, '3', '2012-05-14 09:46:15', '$1000000A'),
(6, 3, 2, 2, 'import java.io.*;\r\nimport java.util.*;\r\npublic class Main\r\n{\r\n    public static void main(String[] args)\r\n    {\r\n        Scanner cin = new Scanner ( System.in );\r\n        int a,b;\r\n        while(cin.hasNext())\r\n        {\r\n            a=cin.nextInt();\r\n            b=cin.nextInt();\r\n            System.out.println(a+b);\r\n        }\r\n\r\n    }\r\n}', 999, 999, '3', '2012-05-14 09:46:33', '$1000000B');

-- --------------------------------------------------------

--
-- 表的结构 `ojlanguage`
--

CREATE TABLE IF NOT EXISTS `ojlanguage` (
  `ojlId` int(11) NOT NULL AUTO_INCREMENT,
  `ojlName` varchar(32) NOT NULL DEFAULT 'C' COMMENT '语言名字',
  `ojlCompiler` varchar(32) NOT NULL DEFAULT 'GCC' COMMENT '编译器名字',
  `ojlCompilerPath` varchar(256) NOT NULL COMMENT '编译器的路径',
  `ojlCompileArgs` varchar(256) NOT NULL COMMENT '编译时参数',
  `ojlMemo` text COMMENT '备注',
  PRIMARY KEY (`ojlId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='OJ中使用的语言' AUTO_INCREMENT=6 ;

--
-- 转存表中的数据 `ojlanguage`
--

INSERT INTO `ojlanguage` (`ojlId`, `ojlName`, `ojlCompiler`, `ojlCompilerPath`, `ojlCompileArgs`, `ojlMemo`) VALUES
(1, 'C', 'GCC', 'GCC', 'GCC_Path %s -o %s -O2 -Wall -lm -std=99 -DONLINE_JUDGE\\r\\n', NULL),
(2, 'C++', 'GCC', 'GCC', 'GCC_Path %s -o %s -O2 -Wall -lm -std=99 -DONLINE_JUDGE', NULL),
(3, 'Java', 'Javac', 'Javac', 'Javac', NULL),
(4, 'Pascal', 'Pascal', 'Pascal', 'Pascal', NULL),
(5, 'Python', 'Python', 'Python', 'Python', NULL);

-- --------------------------------------------------------

--
-- 表的结构 `ojlinks`
--

CREATE TABLE IF NOT EXISTS `ojlinks` (
  `ojliId` int(11) NOT NULL AUTO_INCREMENT COMMENT '链接ID',
  `ojliName` varchar(32) NOT NULL DEFAULT 'HuangJacky' COMMENT '链接名字',
  `ojliUrl` varchar(128) NOT NULL DEFAULT 'http://huangjacky.xtreemhost.com' COMMENT '链接地址',
  `ojliImage` varchar(128) DEFAULT NULL COMMENT '链接图片',
  `ojliOpenType` int(11) DEFAULT NULL COMMENT '链接打开方式',
  `ojliMemo` text,
  PRIMARY KEY (`ojliId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OJ系统友情链接' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `ojnotice`
--

CREATE TABLE IF NOT EXISTS `ojnotice` (
  `ojnId` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告Id',
  `ojuId` int(11) NOT NULL COMMENT '用户ID',
  `ojnTitle` varchar(256) NOT NULL DEFAULT 'Welcome' COMMENT '公告标题',
  `ojnContent` text NOT NULL COMMENT '公告内容',
  `ojnTime` datetime DEFAULT NULL COMMENT '公告发布时间',
  `ojnMemo` text,
  PRIMARY KEY (`ojnId`),
  KEY `FK_管理员发布公告` (`ojuId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='OJ系统的公告' AUTO_INCREMENT=6 ;

--
-- 转存表中的数据 `ojnotice`
--

INSERT INTO `ojnotice` (`ojnId`, `ojuId`, `ojnTitle`, `ojnContent`, `ojnTime`, `ojnMemo`) VALUES
(1, 1, 'æ­¦æ±‰ç†å·¥å¤§å­¦Judge Online ', 'æ­¦æ±‰ç†å·¥å¤§å­¦Judge Onlineç³»ç»Ÿæ˜¯ä¸€ä¸ªåœ¨çº¿çš„åˆ¤é¢˜ç³»ç»Ÿã€‚ç”¨æˆ·å¯ä»¥åœ¨çº¿æäº¤ç¨‹åºå¤šç§ç¨‹åºï¼ˆå¦‚Cã€C++ï¼‰æºä»£ç ï¼Œç³»ç»Ÿå¯¹æºä»£ç è¿›è¡Œç¼–è¯‘å’Œæ‰§è¡Œï¼Œå¹¶é€šè¿‡é¢„å…ˆè®¾è®¡çš„æµ‹è¯•æ•°æ®æ¥æ£€éªŒç¨‹åºæºä»£ç çš„æ­£ç¡®æ€§ã€‚æœ¬ç³»ç»Ÿå¹¶æä¾›ä¸°å¯Œçš„äº¤äº’ï¼Œå¼ºå¤§çš„SNSåŠŸèƒ½æ–¹ä¾¿ç”¨æˆ·äº¤æµã€‚', '2012-04-14 15:26:07', NULL),
(2, 1, 'æ­¦æ±‰ç†å·¥å¤§å­¦Judge Online ', 'ç³»ç»Ÿç®€ä»‹\r\nOnline Judgeç³»ç»Ÿï¼ˆç®€ç§°OJï¼‰æ˜¯ä¸€ä¸ªåœ¨çº¿çš„åˆ¤é¢˜ç³»ç»Ÿã€‚ç”¨æˆ·å¯ä»¥åœ¨çº¿æäº¤ç¨‹åºå¤šç§ç¨‹åºï¼ˆå¦‚Cã€C++ï¼‰æºä»£ç ï¼Œç³»ç»Ÿå¯¹æºä»£ç è¿›è¡Œç¼–è¯‘å’Œæ‰§è¡Œï¼Œå¹¶é€šè¿‡é¢„å…ˆè®¾è®¡çš„æµ‹è¯•æ•°æ®æ¥æ£€éªŒç¨‹åºæºä»£ç çš„æ­£ç¡®æ€§ã€‚\r\nä¸€ä¸ªç”¨æˆ·æäº¤çš„ç¨‹åºåœ¨Online Judgeç³»ç»Ÿä¸‹æ‰§è¡Œæ—¶å°†å—åˆ°æ¯”è¾ƒä¸¥æ ¼çš„é™åˆ¶ï¼ŒåŒ…æ‹¬è¿è¡Œæ—¶é—´é™åˆ¶ï¼Œå†…å­˜ä½¿ç”¨é™åˆ¶å’Œå®‰å…¨é™åˆ¶ç­‰ã€‚ç”¨æˆ·ç¨‹åºæ‰§è¡Œçš„ç»“æžœå°†è¢«Online Judgeç³»ç»Ÿæ•æ‰å¹¶ä¿å­˜ï¼Œç„¶åŽå†è½¬äº¤ç»™ä¸€ä¸ªè£åˆ¤ç¨‹åºã€‚è¯¥è£åˆ¤ç¨‹åºæˆ–è€…æ¯”è¾ƒç”¨æˆ·ç¨‹åºçš„è¾“å‡ºæ•°æ®å’Œæ ‡å‡†è¾“å‡ºæ ·ä¾‹çš„å·®åˆ«ï¼Œæˆ–è€…æ£€éªŒç”¨æˆ·ç¨‹åºçš„è¾“å‡ºæ•°æ®æ˜¯å¦æ»¡è¶³ä¸€å®šçš„é€»è¾‘æ¡ä»¶ã€‚æœ€åŽç³»ç»Ÿè¿”å›žç»™ç”¨æˆ·ä¸€ä¸ªçŠ¶æ€ï¼šé€šè¿‡ï¼ˆAccepted,ACï¼‰ã€ç­”æ¡ˆé”™è¯¯(Wrong Answer,WA)ã€è¶…æ—¶(Time Limit Exceed,TLE)ã€è¶…è¿‡è¾“å‡ºé™åˆ¶ï¼ˆOutput Limit Exceed,OLE)ã€è¶…å†…å­˜ï¼ˆMemory Limit Exceed,MLEï¼‰ã€è¿è¡Œæ—¶é”™è¯¯ï¼ˆRuntime Error,REï¼‰ã€æ ¼å¼é”™è¯¯ï¼ˆPresentation Error,PE)ã€æˆ–æ˜¯æ— æ³•ç¼–è¯‘ï¼ˆCompile Error,CEï¼‰ï¼Œå¹¶è¿”å›žç¨‹åºä½¿ç”¨çš„å†…å­˜ã€è¿è¡Œæ—¶é—´ç­‰ä¿¡æ¯ã€‚\r\nOnline Judgeç³»ç»Ÿæœ€åˆä½¿ç”¨äºŽACM-ICPCå›½é™…å¤§å­¦ç”Ÿç¨‹åºè®¾è®¡ç«žèµ›å’ŒOIä¿¡æ¯å­¦å¥¥æž—åŒ¹å…‹ç«žèµ›ä¸­çš„è‡ªåŠ¨åˆ¤é¢˜å’ŒæŽ’åã€‚çŽ°å¹¿æ³›åº”ç”¨äºŽä¸–ç•Œå„åœ°é«˜æ ¡å­¦ç”Ÿç¨‹åºè®¾è®¡çš„è®­ç»ƒã€å‚èµ›é˜Ÿå‘˜çš„è®­ç»ƒå’Œé€‰æ‹”ã€å„ç§ç¨‹åºè®¾è®¡ç«žèµ›ä»¥åŠæ•°æ®ç»“æž„å’Œç®—æ³•çš„å­¦ä¹ å’Œä½œä¸šçš„è‡ªåŠ¨æäº¤åˆ¤æ–­ä¸­ã€‚\r\nçŸ¥åçš„OJæœ‰ï¼šRQNOJ,URAL,SPOJ,vijos,tyvj,USACO,sgu,pku(poj),zju(toj),tju,uvaç­‰ã€‚', '2012-04-14 15:26:34', NULL),
(3, 1, 'What is GFW?', 'The Great Firewall of China, a well-known part of the Chinese government''s censorship of the Internet.To people in Mainland China "GFW" means the government can forbid something they do not want.', '2012-04-23 14:47:06', NULL),
(4, 1, 'æ­¦æ±‰ç†å·¥å¤§å­¦Judge Online', 'æ­¦æ±‰ç†å·¥å¤§å­¦Judge Onlineç³»ç»Ÿæ˜¯ä¸€ä¸ªåœ¨çº¿çš„åˆ¤é¢˜ç³»ç»Ÿã€‚ç”¨æˆ·å¯ä»¥åœ¨çº¿æäº¤ç¨‹åºå¤šç§ç¨‹åºï¼ˆå¦‚Cã€C++ï¼‰æºä»£ç ï¼Œç³»ç»Ÿå¯¹æºä»£ç è¿›è¡Œç¼–è¯‘å’Œæ‰§è¡Œï¼Œå¹¶é€šè¿‡é¢„å…ˆè®¾è®¡çš„æµ‹è¯•æ•°æ®æ¥æ£€éªŒç¨‹åºæºä»£ç çš„æ­£ç¡®æ€§ã€‚æœ¬ç³»ç»Ÿå¹¶æä¾›ä¸°å¯Œçš„äº¤äº’ï¼Œå¼ºå¤§çš„SNSåŠŸèƒ½æ–¹ä¾¿ç”¨æˆ·äº¤æµã€‚', '2012-04-23 14:17:24', NULL),
(5, 1, 'æ­¦æ±‰ç†å·¥å¤§å­¦Judge Online', 'æ­¦æ±‰ç†å·¥å¤§å­¦Judge Onlineç³»ç»Ÿæ˜¯ä¸€ä¸ªåœ¨çº¿çš„åˆ¤é¢˜ç³»ç»Ÿã€‚ç”¨æˆ·å¯ä»¥åœ¨çº¿æäº¤ç¨‹åºå¤šç§ç¨‹åºï¼ˆå¦‚Cã€C++ï¼‰æºä»£ç ï¼Œç³»ç»Ÿå¯¹æºä»£ç è¿›è¡Œç¼–è¯‘å’Œæ‰§è¡Œï¼Œå¹¶é€šè¿‡é¢„å…ˆè®¾è®¡çš„æµ‹è¯•æ•°æ®æ¥æ£€éªŒç¨‹åºæºä»£ç çš„æ­£ç¡®æ€§ã€‚æœ¬ç³»ç»Ÿå¹¶æä¾›ä¸°å¯Œçš„äº¤äº’ï¼Œå¼ºå¤§çš„SNSåŠŸèƒ½æ–¹ä¾¿ç”¨æˆ·äº¤æµã€‚', '2012-04-23 14:17:51', NULL);

-- --------------------------------------------------------

--
-- 表的结构 `ojquestion`
--

CREATE TABLE IF NOT EXISTS `ojquestion` (
  `ojqId` int(11) NOT NULL AUTO_INCREMENT COMMENT '习题id',
  `ojuId` int(11) NOT NULL COMMENT '用户ID',
  `ojqEnName` varchar(256) NOT NULL DEFAULT 'one add one' COMMENT '习题英文名',
  `ojqChName` varchar(128) NOT NULL DEFAULT '壹加壹' COMMENT '习题中文名',
  `ojqEnContent` text NOT NULL COMMENT '习题英文内容',
  `ojqChContent` text NOT NULL COMMENT '习题中文内容',
  `ojqScore` int(11) DEFAULT '10' COMMENT '习题的分值',
  `ojqComplete` tinyint(1) DEFAULT '0' COMMENT '习题是否被答对过',
  `ojqInput` text COMMENT '模拟输入数据',
  `ojqOutput` text COMMENT '习题正确答案',
  `ojqRequireTime` int(11) DEFAULT '1000' COMMENT '习题要求运行时间,单位ms',
  `ojqRequireMemory` int(11) DEFAULT '10240' COMMENT '习题运行可用内存,单位B',
  `ojqTime` datetime DEFAULT NULL COMMENT '习题创建时间',
  `ojqMemo` text,
  PRIMARY KEY (`ojqId`),
  KEY `FK_管理员发布习题` (`ojuId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='OJ习题' AUTO_INCREMENT=4 ;

--
-- 转存表中的数据 `ojquestion`
--

INSERT INTO `ojquestion` (`ojqId`, `ojuId`, `ojqEnName`, `ojqChName`, `ojqEnContent`, `ojqChContent`, `ojqScore`, `ojqComplete`, `ojqInput`, `ojqOutput`, `ojqRequireTime`, `ojqRequireMemory`, `ojqTime`, `ojqMemo`) VALUES
(1, 1, 'A+B Problem', 'A+B Problem', 'Calculate a+b', 'Calculate a+b\r\nInput two integer a,b (0<=a,b<=10)\r\nOutput a+b', 10, NULL, '1,2', '3', 1000, 10000, '2012-04-14 15:28:13', NULL),
(2, 1, 'Exponentiation', 'Exponentiation', 'Problems involving the computation of exact values of very large magnitude and precision are common. For example, the computation of the national debt is a taxing experience for many computer systems. \r\n\r\nThis problem requires that you write a program to compute the exact value of Rn where R is a real number ( 0.0 < R < 99.999 ) and n is an integer such that 0 < n <= 25.', 'Problems involving the computation of exact values of very large magnitude and precision are common. For example, the computation of the national debt is a taxing experience for many computer systems. \r\n\r\nThis problem requires that you write a program to compute the exact value of Rn where R is a real number ( 0.0 < R < 99.999 ) and n is an integer such that 0 < n <= 25.', 11, NULL, '95.123 12 0.4321 20 5.1234 15 6.7592  9 98.999 10 1.0100 12', '548815620517731830194541.899025343415715973535967221869852721 .00000005148554641076956121994511276767154838481760200726351203835429763013462401 43992025569.928573701266488041146654993318703707511666295476720493953024 29448126.764121021618164430206909037173276672 90429072743629540498.107596019456651774561044010001 1.126825030131969720661201', 500, 10000, '2012-04-14 15:30:49', NULL),
(3, 2, 'Communication System', 'Communication System', 'We have received an order from Pizoor Communications Inc. for a special communication system. The system consists of several devices. For each device, we are free to choose from several manufacturers. Same devices from two manufacturers differ in their maximum bandwidths and prices. \r\nBy overall bandwidth (B) we mean the minimum of the bandwidths of the chosen devices in the communication system and the total price (P) is the sum of the prices of all chosen devices. Our goal is to choose a manufacturer for each device to maximize B/P. ', 'We have received an order from Pizoor Communications Inc. for a special communication system. The system consists of several devices. For each device, we are free to choose from several manufacturers. Same devices from two manufacturers differ in their maximum bandwidths and prices. \r\nBy overall bandwidth (B) we mean the minimum of the bandwidths of the chosen devices in the communication system and the total price (P) is the sum of the prices of all chosen devices. Our goal is to choose a manufacturer for each device to maximize B/P. ', 12, NULL, '1 3\r\n3 100 25 150 35 80 25\r\n2 120 80 155 40\r\n2 100 100 120 110', '0.649', 1000, 10000, '2012-04-14 15:54:28', 'wait');

-- --------------------------------------------------------

--
-- 表的结构 `ojscore`
--

CREATE TABLE IF NOT EXISTS `ojscore` (
  `ojsId` int(11) NOT NULL AUTO_INCREMENT COMMENT '得分Id',
  `ojuId` int(11) NOT NULL COMMENT '用户ID',
  `ojqId` int(11) NOT NULL COMMENT '习题id',
  `ojsTime` datetime DEFAULT NULL COMMENT '得分时间',
  `ojsTimes` int(11) DEFAULT '1' COMMENT '得分倍数',
  `ojsMemo` text,
  PRIMARY KEY (`ojsId`),
  KEY `FK_得分的问题` (`ojqId`),
  KEY `FK_用户的得分` (`ojuId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OJ得分表' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `ojuser`
--

CREATE TABLE IF NOT EXISTS `ojuser` (
  `ojuId` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `ojuName` varchar(32) NOT NULL DEFAULT 'Jacky' COMMENT '用户名',
  `ojuPassword` varchar(32) NOT NULL DEFAULT 'noword' COMMENT '用户密码',
  `ojuEmail` varchar(64) DEFAULT 'test@163.com' COMMENT '邮件',
  `ojuGender` tinyint(1) DEFAULT '0' COMMENT '性别,女真男假',
  `ojuQQ` varchar(24) DEFAULT '123456' COMMENT 'QQ',
  `ojuMSN` varchar(64) DEFAULT 'test@hotmail.com' COMMENT 'MSN',
  `ojuImgDefined` tinyint(1) DEFAULT '0' COMMENT '自定义头像否',
  `ojuImgUrl` varchar(32) DEFAULT NULL COMMENT '头像的地址',
  `ojuRegisterTime` datetime DEFAULT NULL COMMENT '注册时间',
  `ojuLastTime` datetime DEFAULT NULL COMMENT '上次登陆时间',
  `ojuMemo` text COMMENT '备注',
  `ojuAdmin` tinyint(1) DEFAULT '0' COMMENT '是否管理员',
  PRIMARY KEY (`ojuId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='OJ用户' AUTO_INCREMENT=3 ;

--
-- 转存表中的数据 `ojuser`
--

INSERT INTO `ojuser` (`ojuId`, `ojuName`, `ojuPassword`, `ojuEmail`, `ojuGender`, `ojuQQ`, `ojuMSN`, `ojuImgDefined`, `ojuImgUrl`, `ojuRegisterTime`, `ojuLastTime`, `ojuMemo`, `ojuAdmin`) VALUES
(1, 'whutoj', '6ee2fa93b0c4deb89e6235a6ab3ad722', 'whutoj@whut.edu.cn', 0, '888888', 'whutoj@whut.edu.cn', 0, NULL, '2012-04-14 15:22:38', '2012-05-14 10:15:37', NULL, 1),
(2, 'whutoj_user', '6ee2fa93b0c4deb89e6235a6ab3ad722', 'whutoj1@whut.edu.cn', 0, '888888', 'whutoj@whut.edu.cn', 0, NULL, '2012-04-14 15:52:07', '2012-05-14 09:13:09', NULL, 0);

--
-- 限制导出的表
--

--
-- 限制表 `ojanswer`
--
ALTER TABLE `ojanswer`
  ADD CONSTRAINT `FK_用户提交的答案` FOREIGN KEY (`ojuId`) REFERENCES `ojuser` (`ojuId`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_答案使用的语言` FOREIGN KEY (`ojlId`) REFERENCES `ojlanguage` (`ojlId`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_问题提交的答案` FOREIGN KEY (`ojqId`) REFERENCES `ojquestion` (`ojqId`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- 限制表 `ojnotice`
--
ALTER TABLE `ojnotice`
  ADD CONSTRAINT `FK_管理员发布公告` FOREIGN KEY (`ojuId`) REFERENCES `ojuser` (`ojuId`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- 限制表 `ojquestion`
--
ALTER TABLE `ojquestion`
  ADD CONSTRAINT `FK_管理员发布习题` FOREIGN KEY (`ojuId`) REFERENCES `ojuser` (`ojuId`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- 限制表 `ojscore`
--
ALTER TABLE `ojscore`
  ADD CONSTRAINT `FK_用户的得分` FOREIGN KEY (`ojuId`) REFERENCES `ojuser` (`ojuId`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_得分的问题` FOREIGN KEY (`ojqId`) REFERENCES `ojquestion` (`ojqId`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
